Overview

Brought to you by YData

Dataset statistics

Number of variables	23
Number of observations	1296675
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	227.5 MiB
Average record size in memory	184.0 B

Variable types

Numeric	10
DateTime	2
Text	8
Categorical	3

Alerts

`Unnamed: 0` is highly overall correlated with `unix_time`	High correlation
`lat` is highly overall correlated with `merch_lat`	High correlation
`long` is highly overall correlated with `merch_long` and 1 other fields	High correlation
`merch_lat` is highly overall correlated with `lat`	High correlation
`merch_long` is highly overall correlated with `long` and 1 other fields	High correlation
`unix_time` is highly overall correlated with `Unnamed: 0`	High correlation
`zip` is highly overall correlated with `long` and 1 other fields	High correlation
`is_fraud` is highly imbalanced (94.9%)	Imbalance
`amt` is highly skewed (γ1 = 42.27787379)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`trans_num` has unique values	Unique

Reproduction

Analysis started	2025-10-04 12:59:41.408104
Analysis finished	2025-10-04 13:01:42.926289
Duration	2 minutes and 1.52 second
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

High correlation Uniform Unique

Distinct	1296675
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	648337

Minimum	0
Maximum	1296674
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	0
5-th percentile	64833.7
Q1	324168.5
median	648337
Q3	972505.5
95-th percentile	1231840.3
Maximum	1296674
Range	1296674
Interquartile range (IQR)	648337

Descriptive statistics

Standard deviation	374317.97
Coefficient of variation (CV)	0.57735094
Kurtosis	-1.2
Mean	648337
Median Absolute Deviation (MAD)	324169
Skewness	-5.1691189 × 10^-15
Sum	8.4068238 × 10¹¹
Variance	1.4011395 × 10¹¹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1296674	1	< 0.1%
0	1	< 0.1%
1	1	< 0.1%
1296658	1	< 0.1%
1296657	1	< 0.1%
1296656	1	< 0.1%
1296655	1	< 0.1%
1296654	1	< 0.1%
1296653	1	< 0.1%
1296652	1	< 0.1%
Other values (1296665)	1296665	> 99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
1296674	1	< 0.1%
1296673	1	< 0.1%
1296672	1	< 0.1%
1296671	1	< 0.1%
1296670	1	< 0.1%
1296669	1	< 0.1%
1296668	1	< 0.1%
1296667	1	< 0.1%
1296666	1	< 0.1%
1296665	1	< 0.1%

trans_date_trans_time
Date

Distinct	1274791
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Minimum	2019-01-01 00:00:18
Maximum	2020-06-21 12:13:37
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

cc_num
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1719204 × 10¹⁷

Minimum	6.0416207 × 10¹⁰
Maximum	4.9923464 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	6.0416207 × 10¹⁰
5-th percentile	6.3048488 × 10¹¹
Q1	1.8004295 × 10¹⁴
median	3.5214173 × 10¹⁵
Q3	4.6422555 × 10¹⁵
95-th percentile	4.497914 × 10¹⁸
Maximum	4.9923464 × 10¹⁸
Range	4.9923463 × 10¹⁸
Interquartile range (IQR)	4.4622125 × 10¹⁵

Descriptive statistics

Standard deviation	1.3088064 × 10¹⁸
Coefficient of variation (CV)	3.1371798
Kurtosis	6.1799499
Mean	4.1719204 × 10¹⁷
Median Absolute Deviation (MAD)	3.0764709 × 10¹⁵
Skewness	2.851879
Sum	-6.7255419 × 10¹⁸
Variance	1.7129743 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.512828415 × 10¹⁸	3123	0.2%
5.713652351 × 10¹¹	3123	0.2%
3.672269902 × 10¹³	3119	0.2%
2.131124026 × 10¹⁴	3117	0.2%
3.54510934 × 10¹⁵	3113	0.2%
6.534628261 × 10¹⁵	3112	0.2%
6.011367958 × 10¹⁵	3110	0.2%
2.720433096 × 10¹⁵	3107	0.2%
6.011438889 × 10¹⁵	3106	0.2%
6.011109737 × 10¹⁵	3101	0.2%
Other values (973)	1265544	97.6%

Value	Count	Frequency (%)
6.041620718 × 10¹⁰	1518	0.1%
6.042292873 × 10¹⁰	1531	0.1%
6.042309813 × 10¹⁰	510	< 0.1%
6.042785159 × 10¹⁰	528	< 0.1%
6.048700208 × 10¹⁰	496	< 0.1%
6.04905963 × 10¹⁰	1010	0.1%
6.049559311 × 10¹⁰	518	< 0.1%
5.018029536 × 10¹¹	1559	0.1%
5.018181333 × 10¹¹	8	< 0.1%
5.018282048 × 10¹¹	515	< 0.1%

Value	Count	Frequency (%)
4.992346398 × 10¹⁸	2059	0.2%
4.989847571 × 10¹⁸	1007	0.1%
4.980323468 × 10¹⁸	532	< 0.1%
4.973530368 × 10¹⁸	1040	0.1%
4.958589672 × 10¹⁸	1476	0.1%
4.95682899 × 10¹⁸	2566	0.2%
4.911818931 × 10¹⁸	9	< 0.1%
4.906628656 × 10¹⁸	2584	0.2%
4.897067971 × 10¹⁸	1038	0.1%
4.890424427 × 10¹⁸	1496	0.1%

merchant
Text

Distinct	693
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	43
Median length	36
Mean length	23.132597
Min length	13

Characters and Unicode

Total characters	29995460
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	fraud_Rippin, Kub and Mann
2nd row	fraud_Heller, Gutmann and Zieme
3rd row	fraud_Lind-Buckridge
4th row	fraud_Kutch, Hermiston and Farrell
5th row	fraud_Keeling-Crist

Value	Count	Frequency (%)
and	474111	15.7%
llc	97780	3.2%
inc	91939	3.0%
sons	73145	2.4%
ltd	70853	2.3%
plc	66475	2.2%
group	50447	1.7%
fraud_kutch	10560	0.3%
fraud_schaefer	9394	0.3%
fraud_streich	9250	0.3%
Other values (804)	2069403	68.4%

Most occurring characters

Value	Count	Frequency (%)
a	2910697	9.7%
r	2695758	9.0%
d	2139780	7.1%
e	1865710	6.2%
u	1857912	6.2%
n	1768848	5.9%
	1726682	5.8%
f	1397378	4.7%
_	1296675	4.3%
o	1129340	3.8%
Other values (45)	11206680	37.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	29995460	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2910697	9.7%
r	2695758	9.0%
d	2139780	7.1%
e	1865710	6.2%
u	1857912	6.2%
n	1768848	5.9%
	1726682	5.8%
f	1397378	4.7%
_	1296675	4.3%
o	1129340	3.8%
Other values (45)	11206680	37.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	29995460	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2910697	9.7%
r	2695758	9.0%
d	2139780	7.1%
e	1865710	6.2%
u	1857912	6.2%
n	1768848	5.9%
	1726682	5.8%
f	1397378	4.7%
_	1296675	4.3%
o	1129340	3.8%
Other values (45)	11206680	37.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	29995460	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2910697	9.7%
r	2695758	9.0%
d	2139780	7.1%
e	1865710	6.2%
u	1857912	6.2%
n	1768848	5.9%
	1726682	5.8%
f	1397378	4.7%
_	1296675	4.3%
o	1129340	3.8%
Other values (45)	11206680	37.4%

category
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

gas_transport	131659
grocery_pos	123638
home	123115
shopping_pos	116672
kids_pets	113035
Other values (9)	688556

Length

Max length	14
Median length	12
Mean length	10.526079
Min length	4

Characters and Unicode

Total characters	13648903
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	misc_net
2nd row	grocery_pos
3rd row	entertainment
4th row	gas_transport
5th row	misc_pos

Common Values

Value	Count	Frequency (%)
gas_transport	131659	10.2%
grocery_pos	123638	9.5%
home	123115	9.5%
shopping_pos	116672	9.0%
kids_pets	113035	8.7%
shopping_net	97543	7.5%
entertainment	94014	7.3%
food_dining	91461	7.1%
personal_care	90758	7.0%
health_fitness	85879	6.6%
Other values (4)	228901	17.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gas_transport	131659	10.2%
grocery_pos	123638	9.5%
home	123115	9.5%
shopping_pos	116672	9.0%
kids_pets	113035	8.7%
shopping_net	97543	7.5%
entertainment	94014	7.3%
food_dining	91461	7.1%
personal_care	90758	7.0%
health_fitness	85879	6.6%
Other values (4)	228901	17.7%

Most occurring characters

Value	Count	Frequency (%)
s	1429026	10.5%
e	1287345	9.4%
o	1231724	9.0%
n	1193757	8.7%
p	1083847	7.9%
t	1076942	7.9%
_	1039039	7.6%
r	917535	6.7%
i	833007	6.1%
a	665234	4.9%
Other values (10)	2891447	21.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13648903	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	1429026	10.5%
e	1287345	9.4%
o	1231724	9.0%
n	1193757	8.7%
p	1083847	7.9%
t	1076942	7.9%
_	1039039	7.6%
r	917535	6.7%
i	833007	6.1%
a	665234	4.9%
Other values (10)	2891447	21.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13648903	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	1429026	10.5%
e	1287345	9.4%
o	1231724	9.0%
n	1193757	8.7%
p	1083847	7.9%
t	1076942	7.9%
_	1039039	7.6%
r	917535	6.7%
i	833007	6.1%
a	665234	4.9%
Other values (10)	2891447	21.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13648903	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	1429026	10.5%
e	1287345	9.4%
o	1231724	9.0%
n	1193757	8.7%
p	1083847	7.9%
t	1076942	7.9%
_	1039039	7.6%
r	917535	6.7%
i	833007	6.1%
a	665234	4.9%
Other values (10)	2891447	21.2%

amt
Real number (ℝ)

Skewed

Distinct	52928
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.351035

Minimum	1
Maximum	28948.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2.44
Q1	9.65
median	47.52
Q3	83.14
95-th percentile	196.31
Maximum	28948.9
Range	28947.9
Interquartile range (IQR)	73.49

Descriptive statistics

Standard deviation	160.31604
Coefficient of variation (CV)	2.2788014
Kurtosis	4545.645
Mean	70.351035
Median Absolute Deviation (MAD)	37.5
Skewness	42.277874
Sum	91222429
Variance	25701.232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.14	542	< 0.1%
1.04	538	< 0.1%
1.25	535	< 0.1%
1.02	533	< 0.1%
1.01	523	< 0.1%
1.05	519	< 0.1%
1.2	516	< 0.1%
1.23	515	< 0.1%
1.08	512	< 0.1%
1.11	509	< 0.1%
Other values (52918)	1291433	99.6%

Value	Count	Frequency (%)
1	222	< 0.1%
1.01	523	< 0.1%
1.02	533	< 0.1%
1.03	499	< 0.1%
1.04	538	< 0.1%
1.05	519	< 0.1%
1.06	471	< 0.1%
1.07	498	< 0.1%
1.08	512	< 0.1%
1.09	496	< 0.1%

Value	Count	Frequency (%)
28948.9	1	< 0.1%
27390.12	1	< 0.1%
27119.77	1	< 0.1%
26544.12	1	< 0.1%
25086.94	1	< 0.1%
17897.24	1	< 0.1%
15305.95	1	< 0.1%
15047.03	1	< 0.1%
15034.18	1	< 0.1%
14849.74	1	< 0.1%

first
Text

Distinct	352
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	11
Median length	9
Mean length	6.0804319
Min length	3

Characters and Unicode

Total characters	7884344
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jennifer
2nd row	Stephanie
3rd row	Edward
4th row	Jeremy
5th row	Tyler

Value	Count	Frequency (%)
christopher	26669	2.1%
robert	21667	1.7%
jessica	20581	1.6%
james	20039	1.5%
michael	20009	1.5%
david	19965	1.5%
jennifer	16940	1.3%
william	16371	1.3%
mary	16346	1.3%
john	16325	1.3%
Other values (342)	1101763	85.0%

Most occurring characters

Value	Count	Frequency (%)
a	1007700	12.8%
e	860878	10.9%
i	618247	7.8%
n	614453	7.8%
r	607072	7.7%
l	388220	4.9%
h	344993	4.4%
s	324237	4.1%
t	311569	4.0%
o	268849	3.4%
Other values (39)	2538126	32.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7884344	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1007700	12.8%
e	860878	10.9%
i	618247	7.8%
n	614453	7.8%
r	607072	7.7%
l	388220	4.9%
h	344993	4.4%
s	324237	4.1%
t	311569	4.0%
o	268849	3.4%
Other values (39)	2538126	32.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7884344	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1007700	12.8%
e	860878	10.9%
i	618247	7.8%
n	614453	7.8%
r	607072	7.7%
l	388220	4.9%
h	344993	4.4%
s	324237	4.1%
t	311569	4.0%
o	268849	3.4%
Other values (39)	2538126	32.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7884344	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1007700	12.8%
e	860878	10.9%
i	618247	7.8%
n	614453	7.8%
r	607072	7.7%
l	388220	4.9%
h	344993	4.4%
s	324237	4.1%
t	311569	4.0%
o	268849	3.4%
Other values (39)	2538126	32.2%

last
Text

Distinct	481
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	11
Median length	10
Mean length	6.1111774
Min length	2

Characters and Unicode

Total characters	7924211
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Banks
2nd row	Gill
3rd row	Sanchez
4th row	White
5th row	Garcia

Value	Count	Frequency (%)
smith	28794	2.2%
williams	23605	1.8%
davis	21910	1.7%
johnson	20034	1.5%
rodriguez	17394	1.3%
martinez	14805	1.1%
jones	13976	1.1%
lewis	12753	1.0%
gonzalez	11799	0.9%
miller	11698	0.9%
Other values (471)	1119907	86.4%

Most occurring characters

Value	Count	Frequency (%)
e	786302	9.9%
r	658748	8.3%
a	648005	8.2%
n	609178	7.7%
o	583517	7.4%
l	489180	6.2%
s	487668	6.2%
i	435378	5.5%
t	288591	3.6%
h	228981	2.9%
Other values (38)	2708663	34.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7924211	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	786302	9.9%
r	658748	8.3%
a	648005	8.2%
n	609178	7.7%
o	583517	7.4%
l	489180	6.2%
s	487668	6.2%
i	435378	5.5%
t	288591	3.6%
h	228981	2.9%
Other values (38)	2708663	34.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7924211	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	786302	9.9%
r	658748	8.3%
a	648005	8.2%
n	609178	7.7%
o	583517	7.4%
l	489180	6.2%
s	487668	6.2%
i	435378	5.5%
t	288591	3.6%
h	228981	2.9%
Other values (38)	2708663	34.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7924211	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	786302	9.9%
r	658748	8.3%
a	648005	8.2%
n	609178	7.7%
o	583517	7.4%
l	489180	6.2%
s	487668	6.2%
i	435378	5.5%
t	288591	3.6%
h	228981	2.9%
Other values (38)	2708663	34.2%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

F	709863
M	586812

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	F
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	709863	54.7%
m	586812	45.3%

Most occurring characters

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1296675	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1296675	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1296675	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
F	709863	54.7%
M	586812	45.3%

street
Text

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	35
Median length	29
Mean length	22.229027
Min length	12

Characters and Unicode

Total characters	28823823
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	561 Perry Cove
2nd row	43039 Riley Greens Suite 393
3rd row	594 White Dale Suite 530
4th row	9443 Cynthia Court Apt. 038
5th row	408 Bradley Rest

Value	Count	Frequency (%)
apt	327791	6.4%
suite	305467	5.9%
island	22954	0.4%
michael	18967	0.4%
common	17978	0.3%
station	17957	0.3%
islands	17917	0.3%
david	17476	0.3%
brooks	16991	0.3%
fields	16321	0.3%
Other values (1940)	4376722	84.9%

Most occurring characters

Value	Count	Frequency (%)
	3859866	13.4%
e	1792676	6.2%
a	1454190	5.0%
i	1296969	4.5%
t	1248091	4.3%
r	1103208	3.8%
n	1066149	3.7%
s	1034564	3.6%
l	889594	3.1%
o	875571	3.0%
Other values (52)	14202945	49.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	28823823	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3859866	13.4%
e	1792676	6.2%
a	1454190	5.0%
i	1296969	4.5%
t	1248091	4.3%
r	1103208	3.8%
n	1066149	3.7%
s	1034564	3.6%
l	889594	3.1%
o	875571	3.0%
Other values (52)	14202945	49.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	28823823	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3859866	13.4%
e	1792676	6.2%
a	1454190	5.0%
i	1296969	4.5%
t	1248091	4.3%
r	1103208	3.8%
n	1066149	3.7%
s	1034564	3.6%
l	889594	3.1%
o	875571	3.0%
Other values (52)	14202945	49.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	28823823	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3859866	13.4%
e	1792676	6.2%
a	1454190	5.0%
i	1296969	4.5%
t	1248091	4.3%
r	1103208	3.8%
n	1066149	3.7%
s	1034564	3.6%
l	889594	3.1%
o	875571	3.0%
Other values (52)	14202945	49.3%

city
Text

Distinct	894
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	25
Median length	21
Mean length	8.6522459
Min length	3

Characters and Unicode

Total characters	11219151
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moravian Falls
2nd row	Orient
3rd row	Malad City
4th row	Boulder
5th row	Doe Hill

Value	Count	Frequency (%)
city	21314	1.3%
west	19473	1.2%
north	14425	0.9%
saint	14363	0.9%
falls	12794	0.8%
new	11842	0.7%
mount	11375	0.7%
lake	11249	0.7%
san	10260	0.6%
springs	8727	0.5%
Other values (918)	1482445	91.6%

Most occurring characters

Value	Count	Frequency (%)
e	1090254	9.7%
a	935089	8.3%
n	821831	7.3%
o	817806	7.3%
l	781662	7.0%
r	748921	6.7%
i	704285	6.3%
t	598490	5.3%
s	446306	4.0%
	321592	2.9%
Other values (42)	3952915	35.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11219151	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1090254	9.7%
a	935089	8.3%
n	821831	7.3%
o	817806	7.3%
l	781662	7.0%
r	748921	6.7%
i	704285	6.3%
t	598490	5.3%
s	446306	4.0%
	321592	2.9%
Other values (42)	3952915	35.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11219151	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1090254	9.7%
a	935089	8.3%
n	821831	7.3%
o	817806	7.3%
l	781662	7.0%
r	748921	6.7%
i	704285	6.3%
t	598490	5.3%
s	446306	4.0%
	321592	2.9%
Other values (42)	3952915	35.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11219151	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1090254	9.7%
a	935089	8.3%
n	821831	7.3%
o	817806	7.3%
l	781662	7.0%
r	748921	6.7%
i	704285	6.3%
t	598490	5.3%
s	446306	4.0%
	321592	2.9%
Other values (42)	3952915	35.2%

state
Text

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2593350
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NC
2nd row	WA
3rd row	ID
4th row	MT
5th row	VA

Value	Count	Frequency (%)
tx	94876	7.3%
ny	83501	6.4%
pa	79847	6.2%
ca	56360	4.3%
oh	46480	3.6%
mi	46154	3.6%
il	43252	3.3%
fl	42671	3.3%
al	40989	3.2%
mo	38403	3.0%
Other values (41)	724142	55.8%

Most occurring characters

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2593350	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2593350	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2593350	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	355776	13.7%
N	284464	11.0%
M	220694	8.5%
I	181993	7.0%
T	154353	6.0%
L	147877	5.7%
O	144031	5.6%
C	141011	5.4%
Y	131298	5.1%
X	94876	3.7%
Other values (14)	736977	28.4%

zip
Real number (ℝ)

High correlation

Distinct	970
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48800.671

Minimum	1257
Maximum	99783
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1257
5-th percentile	7208
Q1	26237
median	48174
Q3	72042
95-th percentile	94569
Maximum	99783
Range	98526
Interquartile range (IQR)	45805

Descriptive statistics

Standard deviation	26893.222
Coefficient of variation (CV)	0.55108305
Kurtosis	-1.0964493
Mean	48800.671
Median Absolute Deviation (MAD)	23068
Skewness	0.079680758
Sum	6.327861 × 10¹⁰
Variance	7.2324542 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73754	3646	0.3%
34112	3613	0.3%
48088	3597	0.3%
82514	3527	0.3%
49628	3123	0.2%
15484	3123	0.2%
85173	3119	0.2%
29819	3117	0.2%
38761	3113	0.2%
5461	3112	0.2%
Other values (960)	1263585	97.4%

Value	Count	Frequency (%)
1257	2023	0.2%
1330	1031	0.1%
1535	515	< 0.1%
1545	1024	0.1%
1612	519	< 0.1%
1843	2597	0.2%
1844	2058	0.2%
2180	519	< 0.1%
2630	2090	0.2%
2908	550	< 0.1%

Value	Count	Frequency (%)
99783	1568	0.1%
99747	12	< 0.1%
99746	540	< 0.1%
99323	2572	0.2%
99160	3030	0.2%
99116	15	< 0.1%
99113	1047	0.1%
99033	2458	0.2%
98836	524	< 0.1%
98665	500	< 0.1%

lat
Real number (ℝ)

High correlation

Distinct	968
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.537622

Minimum	20.0271
Maximum	66.6933
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	20.0271
5-th percentile	29.8826
Q1	34.6205
median	39.3543
Q3	41.9404
95-th percentile	45.8433
Maximum	66.6933
Range	46.6662
Interquartile range (IQR)	7.3199

Descriptive statistics

Standard deviation	5.0758084
Coefficient of variation (CV)	0.13171047
Kurtosis	0.81296795
Mean	38.537622
Median Absolute Deviation (MAD)	3.3597
Skewness	-0.18602768
Sum	49970771
Variance	25.763831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36.385	3646	0.3%
26.1184	3613	0.3%
42.5164	3597	0.3%
43.0048	3527	0.3%
39.8936	3123	0.2%
44.5995	3123	0.2%
33.2887	3119	0.2%
34.0326	3117	0.2%
33.4783	3113	0.2%
44.3346	3112	0.2%
Other values (958)	1263585	97.4%

Value	Count	Frequency (%)
20.0271	1527	0.1%
20.0827	1032	0.1%
24.6557	2584	0.2%
26.1184	3613	0.3%
26.3304	542	< 0.1%
26.3771	518	< 0.1%
26.4215	3038	0.2%
26.4722	2524	0.2%
26.529	1549	0.1%
26.6939	1027	0.1%

Value	Count	Frequency (%)
66.6933	12	< 0.1%
65.6899	540	< 0.1%
64.7556	1568	0.1%
48.8878	3030	0.2%
48.8856	2066	0.2%
48.8328	1533	0.1%
48.6669	1047	0.1%
48.6031	2973	0.2%
48.4786	2038	0.2%
48.34	3088	0.2%

long
Real number (ℝ)

High correlation

Distinct	969
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.226335

Minimum	-165.6723
Maximum	-67.9503
Zeros	0
Zeros (%)	0.0%
Negative	1296675
Negative (%)	100.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	-165.6723
5-th percentile	-119.0825
Q1	-96.798
median	-87.4769
Q3	-80.158
95-th percentile	-73.5112
Maximum	-67.9503
Range	97.722
Interquartile range (IQR)	16.64

Descriptive statistics

Standard deviation	13.759077
Coefficient of variation (CV)	-0.15249513
Kurtosis	1.8558923
Mean	-90.226335
Median Absolute Deviation (MAD)	8.1527
Skewness	-1.1501077
Sum	-1.1699423 × 10⁸
Variance	189.3122
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-98.0727	3646	0.3%
-81.7361	3613	0.3%
-82.9832	3597	0.3%
-108.8964	3527	0.3%
-79.7856	3123	0.2%
-86.2141	3123	0.2%
-111.0985	3119	0.2%
-82.2027	3117	0.2%
-90.5142	3113	0.2%
-73.098	3112	0.2%
Other values (959)	1263585	97.4%

Value	Count	Frequency (%)
-165.6723	1568	0.1%
-156.292	540	< 0.1%
-155.488	1032	0.1%
-155.3697	1527	0.1%
-153.994	12	< 0.1%
-124.4409	1043	0.1%
-124.2174	1547	0.1%
-124.1587	1031	0.1%
-124.1437	1526	0.1%
-123.9743	2036	0.2%

Value	Count	Frequency (%)
-67.9503	2080	0.2%
-68.5565	1014	0.1%
-69.2675	519	< 0.1%
-69.4828	2050	0.2%
-69.9576	537	< 0.1%
-69.9656	3107	0.2%
-70.1031	9	< 0.1%
-70.239	1036	0.1%
-70.3001	2090	0.2%
-70.3457	1527	0.1%

city_pop
Real number (ℝ)

Distinct	879
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88824.441

Minimum	23
Maximum	2906700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	23
5-th percentile	139
Q1	743
median	2456
Q3	20328
95-th percentile	525713
Maximum	2906700
Range	2906677
Interquartile range (IQR)	19585

Descriptive statistics

Standard deviation	301956.36
Coefficient of variation (CV)	3.3994738
Kurtosis	37.614519
Mean	88824.441
Median Absolute Deviation (MAD)	2198
Skewness	5.5938531
Sum	1.1517643 × 10¹¹
Variance	9.1177644 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
606	5496	0.4%
1595797	5130	0.4%
1312922	5075	0.4%
1766	4574	0.4%
241	4533	0.3%
2906700	4168	0.3%
276002	4155	0.3%
302	4147	0.3%
910148	4073	0.3%
198	4067	0.3%
Other values (869)	1251257	96.5%

Value	Count	Frequency (%)
23	2049	0.2%
37	1013	0.1%
43	2034	0.2%
46	3040	0.2%
47	511	< 0.1%
49	1054	0.1%
51	1016	0.1%
52	518	< 0.1%
53	2610	0.2%
60	1045	0.1%

Value	Count	Frequency (%)
2906700	4168	0.3%
2504700	2033	0.2%
2383912	521	< 0.1%
1595797	5130	0.4%
1577385	2563	0.2%
1526206	3517	0.3%
1417793	8	< 0.1%
1382480	2056	0.2%
1312922	5075	0.4%
1263321	3629	0.3%

job
Text

Distinct	494
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	59
Median length	38
Mean length	20.227102
Min length	3

Characters and Unicode

Total characters	26227978
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Psychologist, counselling
2nd row	Special educational needs teacher
3rd row	Nature conservation officer
4th row	Patent attorney
5th row	Dance movement psychotherapist

Value	Count	Frequency (%)
engineer	131756	4.6%
officer	110915	3.9%
manager	61124	2.1%
scientist	55878	1.9%
designer	52218	1.8%
surveyor	49062	1.7%
teacher	38126	1.3%
psychologist	32600	1.1%
research	29754	1.0%
editor	28725	1.0%
Other values (456)	2289024	79.5%

Most occurring characters

Value	Count	Frequency (%)
e	2803032	10.7%
i	2386346	9.1%
r	2198669	8.4%
a	1813638	6.9%
t	1782302	6.8%
n	1764769	6.7%
	1582507	6.0%
o	1491775	5.7%
s	1444701	5.5%
c	1323152	5.0%
Other values (43)	7637087	29.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	26227978	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2803032	10.7%
i	2386346	9.1%
r	2198669	8.4%
a	1813638	6.9%
t	1782302	6.8%
n	1764769	6.7%
	1582507	6.0%
o	1491775	5.7%
s	1444701	5.5%
c	1323152	5.0%
Other values (43)	7637087	29.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	26227978	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2803032	10.7%
i	2386346	9.1%
r	2198669	8.4%
a	1813638	6.9%
t	1782302	6.8%
n	1764769	6.7%
	1582507	6.0%
o	1491775	5.7%
s	1444701	5.5%
c	1323152	5.0%
Other values (43)	7637087	29.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	26227978	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2803032	10.7%
i	2386346	9.1%
r	2198669	8.4%
a	1813638	6.9%
t	1782302	6.8%
n	1764769	6.7%
	1582507	6.0%
o	1491775	5.7%
s	1444701	5.5%
c	1323152	5.0%
Other values (43)	7637087	29.1%

dob
Date

Distinct	968
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Minimum	1924-10-30 00:00:00
Maximum	2005-01-29 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

trans_num
Text

Unique

Distinct	1296675
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	41493600
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1296675 ?
Unique (%)	100.0%

Sample

1st row	0b242abb623afc578575680df30655b9
2nd row	1f76529f8574734946361c461b024d99
3rd row	a1a22d70485983eac12b5b88dad1cf95
4th row	6b849c168bdad6f867558c3793159a81
5th row	a41d7549acf90789359a9aa5346dcb46

Value	Count	Frequency (%)
6b849c168bdad6f867558c3793159a81	1	< 0.1%
8f7c8e4ab7f25875d753b422917c98c9	1	< 0.1%
0b242abb623afc578575680df30655b9	1	< 0.1%
d2263b4459d544bedb14a6c0abf04918	1	< 0.1%
de289ff4302f93f9de1ebf1b0152a8ff	1	< 0.1%
cc47f72c6ed03fbf25c724690c2aedfa	1	< 0.1%
42d93aef20d9be92f38f4d1f04671b88	1	< 0.1%
0a2e7ce8ee5f33346f54f9a9605dd335	1	< 0.1%
be0ac1fd89b5d91d5032c052d70e8ed2	1	< 0.1%
108c103b26f686c24c021aaf4210977e	1	< 0.1%
Other values (1296665)	1296665	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
2	2596593	6.3%
9	2596375	6.3%
7	2595084	6.3%
4	2594676	6.3%
a	2594103	6.3%
d	2593816	6.3%
3	2593713	6.3%
f	2593666	6.3%
5	2593098	6.2%
e	2592759	6.2%
Other values (6)	15549717	37.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41493600	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	2596593	6.3%
9	2596375	6.3%
7	2595084	6.3%
4	2594676	6.3%
a	2594103	6.3%
d	2593816	6.3%
3	2593713	6.3%
f	2593666	6.3%
5	2593098	6.2%
e	2592759	6.2%
Other values (6)	15549717	37.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41493600	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	2596593	6.3%
9	2596375	6.3%
7	2595084	6.3%
4	2594676	6.3%
a	2594103	6.3%
d	2593816	6.3%
3	2593713	6.3%
f	2593666	6.3%
5	2593098	6.2%
e	2592759	6.2%
Other values (6)	15549717	37.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41493600	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	2596593	6.3%
9	2596375	6.3%
7	2595084	6.3%
4	2594676	6.3%
a	2594103	6.3%
d	2593816	6.3%
3	2593713	6.3%
f	2593666	6.3%
5	2593098	6.2%
e	2592759	6.2%
Other values (6)	15549717	37.5%

unix_time
Real number (ℝ)

High correlation

Distinct	1274823
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3492436 × 10⁹

Minimum	1.325376 × 10⁹
Maximum	1.3718168 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1.325376 × 10⁹
5-th percentile	1.328672 × 10⁹
Q1	1.3387507 × 10⁹
median	1.3492497 × 10⁹
Q3	1.3593854 × 10⁹
95-th percentile	1.3698306 × 10⁹
Maximum	1.3718168 × 10⁹
Range	46440799
Interquartile range (IQR)	20634633

Descriptive statistics

Standard deviation	12841278
Coefficient of variation (CV)	0.0095173904
Kurtosis	-1.0875405
Mean	1.3492436 × 10⁹
Median Absolute Deviation (MAD)	10358807
Skewness	0.0033779498
Sum	1.7495305 × 10¹⁵
Variance	1.6489843 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1335110521	4	< 0.1%
1370177227	4	< 0.1%
1370050667	4	< 0.1%
1336189441	3	< 0.1%
1344074858	3	< 0.1%
1353279829	3	< 0.1%
1328926546	3	< 0.1%
1371194207	3	< 0.1%
1343668520	3	< 0.1%
1360424531	3	< 0.1%
Other values (1274813)	1296642	> 99.9%

Value	Count	Frequency (%)
1325376018	1	< 0.1%
1325376044	1	< 0.1%
1325376051	1	< 0.1%
1325376076	1	< 0.1%
1325376186	1	< 0.1%
1325376248	1	< 0.1%
1325376282	1	< 0.1%
1325376308	1	< 0.1%
1325376318	1	< 0.1%
1325376361	1	< 0.1%

Value	Count	Frequency (%)
1371816817	1	< 0.1%
1371816816	1	< 0.1%
1371816752	1	< 0.1%
1371816739	1	< 0.1%
1371816728	1	< 0.1%
1371816696	1	< 0.1%
1371816683	1	< 0.1%
1371816656	1	< 0.1%
1371816562	1	< 0.1%
1371816522	1	< 0.1%

merch_lat
Real number (ℝ)

High correlation

Distinct	1247805
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.537338

Minimum	19.027785
Maximum	67.510267
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	19.027785
5-th percentile	29.751653
Q1	34.733572
median	39.36568
Q3	41.957164
95-th percentile	46.00353
Maximum	67.510267
Range	48.482482
Interquartile range (IQR)	7.223592

Descriptive statistics

Standard deviation	5.1097884
Coefficient of variation (CV)	0.13259318
Kurtosis	0.79599391
Mean	38.537338
Median Absolute Deviation (MAD)	3.397536
Skewness	-0.18191543
Sum	49970403
Variance	26.109937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.985166	4	< 0.1%
34.048439	4	< 0.1%
40.160183	4	< 0.1%
38.714096	4	< 0.1%
38.895098	4	< 0.1%
41.847083	4	< 0.1%
42.920584	4	< 0.1%
33.995152	4	< 0.1%
43.373076	4	< 0.1%
43.327495	4	< 0.1%
Other values (1247795)	1296635	> 99.9%

Value	Count	Frequency (%)
19.027785	1	< 0.1%
19.027804	1	< 0.1%
19.029798	1	< 0.1%
19.031242	1	< 0.1%
19.032277	1	< 0.1%
19.033288	1	< 0.1%
19.034282	1	< 0.1%
19.034687	1	< 0.1%
19.035472	1	< 0.1%
19.036312	1	< 0.1%

Value	Count	Frequency (%)
67.510267	1	< 0.1%
67.441518	1	< 0.1%
67.397018	1	< 0.1%
67.188111	1	< 0.1%
67.064277	1	< 0.1%
66.835174	1	< 0.1%
66.682905	1	< 0.1%
66.67355	1	< 0.1%
66.664673	1	< 0.1%
66.659242	1	< 0.1%

merch_long
Real number (ℝ)

High correlation

Distinct	1275745
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.226465

Minimum	-166.67124
Maximum	-66.950902
Zeros	0
Zeros (%)	0.0%
Negative	1296675
Negative (%)	100.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	-166.67124
5-th percentile	-119.33009
Q1	-96.897276
median	-87.438392
Q3	-80.236796
95-th percentile	-73.354218
Maximum	-66.950902
Range	99.72034
Interquartile range (IQR)	16.660479

Descriptive statistics

Standard deviation	13.771091
Coefficient of variation (CV)	-0.15262806
Kurtosis	1.8484792
Mean	-90.226465
Median Absolute Deviation (MAD)	8.227889
Skewness	-1.1469599
Sum	-1.169944 × 10⁸
Variance	189.64294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-81.219189	4	< 0.1%
-74.618269	4	< 0.1%
-87.116414	4	< 0.1%
-80.940524	3	< 0.1%
-94.731038	3	< 0.1%
-73.292772	3	< 0.1%
-82.371419	3	< 0.1%
-84.017557	3	< 0.1%
-83.900064	3	< 0.1%
-82.644696	3	< 0.1%
Other values (1275735)	1296642	> 99.9%

Value	Count	Frequency (%)
-166.671242	1	< 0.1%
-166.670132	1	< 0.1%
-166.669638	1	< 0.1%
-166.666179	1	< 0.1%
-166.664828	1	< 0.1%
-166.662888	1	< 0.1%
-166.661968	1	< 0.1%
-166.659277	1	< 0.1%
-166.657834	1	< 0.1%
-166.657174	1	< 0.1%

Value	Count	Frequency (%)
-66.950902	1	< 0.1%
-66.955996	1	< 0.1%
-66.95654	1	< 0.1%
-66.958659	1	< 0.1%
-66.958751	1	< 0.1%
-66.959178	1	< 0.1%
-66.961923	1	< 0.1%
-66.962913	1	< 0.1%
-66.963918	1	< 0.1%
-66.963975	1	< 0.1%

is_fraud
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	1289169
1	7506

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring characters

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1296675	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1296675	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1296675	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Interactions

Correlations

	Unnamed: 0	amt	category	cc_num	city_pop	gender	is_fraud	lat	long	merch_lat	merch_long	unix_time	zip
Unnamed: 0	1.000	0.001	0.001	0.002	-0.003	0.000	0.019	0.001	-0.001	0.001	-0.001	1.000	0.001
amt	0.001	1.000	0.020	-0.001	-0.024	0.000	0.000	0.012	-0.000	0.012	0.000	0.001	0.001
category	0.001	0.020	1.000	0.009	0.014	0.054	0.071	0.011	0.009	0.011	0.009	0.001	0.011
cc_num	0.002	-0.001	0.009	1.000	0.049	0.051	0.006	-0.004	-0.013	-0.004	-0.013	0.002	0.013
city_pop	-0.003	-0.024	0.014	0.049	1.000	0.089	0.004	-0.265	0.087	-0.264	0.086	-0.003	-0.040
gender	0.000	0.000	0.054	0.051	0.089	1.000	0.008	0.101	0.091	0.103	0.082	0.000	0.119
is_fraud	0.019	0.000	0.071	0.006	0.004	0.008	1.000	0.008	0.006	0.008	0.005	0.018	0.005
lat	0.001	0.012	0.011	-0.004	-0.265	0.101	0.008	1.000	0.106	0.991	0.105	0.001	-0.162
long	-0.001	-0.000	0.009	-0.013	0.087	0.091	0.006	0.106	1.000	0.106	0.998	-0.001	-0.959
merch_lat	0.001	0.012	0.011	-0.004	-0.264	0.103	0.008	0.991	0.106	1.000	0.104	0.001	-0.162
merch_long	-0.001	0.000	0.009	-0.013	0.086	0.082	0.005	0.105	0.998	0.104	1.000	-0.001	-0.957
unix_time	1.000	0.001	0.001	0.002	-0.003	0.000	0.018	0.001	-0.001	0.001	-0.001	1.000	0.001
zip	0.001	0.001	0.011	0.013	-0.040	0.119	0.005	-0.162	-0.959	-0.162	-0.957	0.001	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Unnamed: 0	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long
0	0	2019-01-01 00:00:18	2703186189652095	fraud_Rippin, Kub and Mann	misc_net	4.97	Jennifer	Banks	F	561 Perry Cove	Moravian Falls	NC	28654	36.0788	-81.1781	3495	Psychologist, counselling	1988-03-09	0b242abb623afc578575680df30655b9	1325376018	36.011293	-82.048315
1	1	2019-01-01 00:00:44	630423337322	fraud_Heller, Gutmann and Zieme	grocery_pos	107.23	Stephanie	Gill	F	43039 Riley Greens Suite 393	Orient	WA	99160	48.8878	-118.2105	149	Special educational needs teacher	1978-06-21	1f76529f8574734946361c461b024d99	1325376044	49.159047	-118.186462
2	2	2019-01-01 00:00:51	38859492057661	fraud_Lind-Buckridge	entertainment	220.11	Edward	Sanchez	M	594 White Dale Suite 530	Malad City	ID	83252	42.1808	-112.2620	4154	Nature conservation officer	1962-01-19	a1a22d70485983eac12b5b88dad1cf95	1325376051	43.150704	-112.154481
3	3	2019-01-01 00:01:16	3534093764340240	fraud_Kutch, Hermiston and Farrell	gas_transport	45.00	Jeremy	White	M	9443 Cynthia Court Apt. 038	Boulder	MT	59632	46.2306	-112.1138	1939	Patent attorney	1967-01-12	6b849c168bdad6f867558c3793159a81	1325376076	47.034331	-112.561071
4	4	2019-01-01 00:03:06	375534208663984	fraud_Keeling-Crist	misc_pos	41.96	Tyler	Garcia	M	408 Bradley Rest	Doe Hill	VA	24433	38.4207	-79.4629	99	Dance movement psychotherapist	1986-03-28	a41d7549acf90789359a9aa5346dcb46	1325376186	38.674999	-78.632459
5	5	2019-01-01 00:04:08	4767265376804500	fraud_Stroman, Hudson and Erdman	gas_transport	94.63	Jennifer	Conner	F	4655 David Island	Dublin	PA	18917	40.3750	-75.2045	2158	Transport planner	1961-06-19	189a841a0a8ba03058526bcfe566aab5	1325376248	40.653382	-76.152667
6	6	2019-01-01 00:04:42	30074693890476	fraud_Rowe-Vandervort	grocery_net	44.54	Kelsey	Richards	F	889 Sarah Station Suite 624	Holcomb	KS	67851	37.9931	-100.9893	2691	Arboriculturist	1993-08-16	83ec1cc84142af6e2acf10c44949e720	1325376282	37.162705	-100.153370
7	7	2019-01-01 00:05:08	6011360759745864	fraud_Corwin-Collins	gas_transport	71.65	Steven	Williams	M	231 Flores Pass Suite 720	Edinburg	VA	22824	38.8432	-78.6003	6018	Designer, multimedia	1947-08-21	6d294ed2cc447d2c71c7171a3d54967c	1325376308	38.948089	-78.540296
8	8	2019-01-01 00:05:18	4922710831011201	fraud_Herzog Ltd	misc_pos	4.27	Heather	Chase	F	6888 Hicks Stream Suite 954	Manor	PA	15665	40.3359	-79.6607	1472	Public affairs consultant	1941-03-07	fc28024ce480f8ef21a32d64c93a29f5	1325376318	40.351813	-79.958146
9	9	2019-01-01 00:06:01	2720830304681674	fraud_Schoen, Kuphal and Nitzsche	grocery_pos	198.39	Melissa	Aguilar	F	21326 Taylor Squares Suite 708	Clarksville	TN	37040	36.5220	-87.3490	151785	Pathologist	1974-03-28	3b9014ea8fb80bd65de0b1463b00b00e	1325376361	37.179198	-87.485381

	Unnamed: 0	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long
1296665	1296665	2020-06-21 12:08:42	213193596103206	fraud_Gulgowski LLC	home	72.17	James	Hunt	M	7369 Gabriel Tunnel	Pointe Aux Pins	MI	49775	45.7549	-84.4470	95	Electrical engineer	1994-02-09	108c103b26f686c24c021aaf4210977e	1371816522	44.938461	-83.996234
1296666	1296666	2020-06-21 12:09:22	4587657402165341815	fraud_Hyatt, Russel and Gleichner	health_fitness	7.30	Amber	Lewis	F	6296 John Keys Suite 858	Pembroke Township	IL	60958	41.0646	-87.5917	2135	Psychotherapist, child	2004-05-08	37a18c6fb0c5c722b6339ffedc82f55a	1371816562	40.556811	-88.092339
1296667	1296667	2020-06-21 12:10:56	4822367783500458	fraud_Hahn, Douglas and Schowalter	travel	19.71	Christopher	Farrell	M	97070 Anderson Land	Haines City	FL	33844	28.0758	-81.5929	33804	Exercise physiologist	1991-01-01	34e72e0a659a6c8f4a20ee65594f3a7d	1371816656	27.465871	-81.511804
1296668	1296668	2020-06-21 12:11:23	213141712584544	fraud_Metz, Russel and Metz	kids_pets	100.85	Margaret	Curtis	F	742 Oneill Shore	Florence	MS	39073	32.1530	-90.1217	19685	Fine artist	1984-12-24	0d86d8c17638d7eff77db9c6a878b477	1371816683	31.377697	-90.528450
1296669	1296669	2020-06-21 12:11:36	4400011257587661852	fraud_Stiedemann Inc	misc_pos	37.38	Marissa	Powell	F	474 Allen Haven	North Loup	NE	68859	41.4972	-98.7858	509	Nurse, children's	1980-09-15	9a7ea2625cf8303efe34e3c09546868f	1371816696	41.728638	-99.039660
1296670	1296670	2020-06-21 12:12:08	30263540414123	fraud_Reichel Inc	entertainment	15.56	Erik	Patterson	M	162 Jessica Row Apt. 072	Hatch	UT	84735	37.7175	-112.4777	258	Geoscientist	1961-11-24	440b587732da4dc1a6395aba5fb41669	1371816728	36.841266	-111.690765
1296671	1296671	2020-06-21 12:12:19	6011149206456997	fraud_Abernathy and Sons	food_dining	51.70	Jeffrey	White	M	8617 Holmes Terrace Suite 651	Tuscarora	MD	21790	39.2667	-77.5101	100	Production assistant, television	1979-12-11	278000d2e0d2277d1de2f890067dcc0a	1371816739	38.906881	-78.246528
1296672	1296672	2020-06-21 12:12:32	3514865930894695	fraud_Stiedemann Ltd	food_dining	105.93	Christopher	Castaneda	M	1632 Cohen Drive Suite 639	High Rolls Mountain Park	NM	88325	32.9396	-105.8189	899	Naval architect	1967-08-30	483f52fe67fabef353d552c1e662974c	1371816752	33.619513	-105.130529
1296673	1296673	2020-06-21 12:13:36	2720012583106919	fraud_Reinger, Weissnat and Strosin	food_dining	74.90	Joseph	Murray	M	42933 Ryan Underpass	Manderson	SD	57756	43.3526	-102.5411	1126	Volunteer coordinator	1980-08-18	d667cdcbadaaed3da3f4020e83591c83	1371816816	42.788940	-103.241160
1296674	1296674	2020-06-21 12:13:37	4292902571056973207	fraud_Langosh, Wintheiser and Hyatt	food_dining	4.30	Jeffrey	Smith	M	135 Joseph Mountains	Sula	MT	59871	45.8433	-113.8748	218	Therapist, horticultural	1995-08-16	8f7c8e4ab7f25875d753b422917c98c9	1371816817	46.565983	-114.186110

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category